package com.teamall.web.sys.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class SysUserArg {
    private String pk_name = "USER_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<SysUserCriteria> oredCriteria;

    public SysUserArg() {
        oredCriteria = new ArrayList<SysUserCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<SysUserCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(SysUserCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public SysUserCriteria or() {
    	SysUserCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public SysUserCriteria createCriteria() {
    	SysUserCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected SysUserCriteria createCriteriaInternal() {
    	SysUserCriteria criteria = new SysUserCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<SysUserCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<SysUserCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<SysUserCriterion> getAllCriteria() {
            return criteria;
        }

        public List<SysUserCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new SysUserCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new SysUserCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new SysUserCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new SysUserCriterion(condition, value1, value2));
        }

        public SysUserCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andUserIdIsNull() {
            addCriterion("USER_ID is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdIsNotNull() {
            addCriterion("USER_ID is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdEqualTo(Integer value) {
            addCriterion("USER_ID =", value, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdNotEqualTo(Integer value) {
            addCriterion("USER_ID <>", value, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdGreaterThan(Integer value) {
            addCriterion("USER_ID >", value, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("USER_ID >=", value, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdLessThan(Integer value) {
            addCriterion("USER_ID <", value, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("USER_ID <=", value, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdLike(Integer value) {
            addCriterion("USER_ID like ", value, "USER_ID", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdNotLike(Integer value) {
            addCriterion("USER_ID  not like ", value, "USER_ID", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdLeftLike(Integer value) {
            addCriterion("USER_ID like ", value, "USER_ID", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdNotLeftLike(Integer value) {
            addCriterion("USER_ID  not like ", value, "USER_ID", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdRightLike(Integer value) {
            addCriterion("USER_ID like ", value, "USER_ID", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdNotRightLike(Integer value) {
            addCriterion("USER_ID  not like ", value, "USER_ID", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdIn(List<Integer> values) {
            addCriterion("USER_ID  in ", values, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdNotIn(List<Integer> values) {
            addCriterion("USER_ID not in ", values, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("USER_ID between ", value1, value2, "USER_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("USER_ID not between ", value1, value2, "USER_ID");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andUserObjTypeIsNull() {
            addCriterion("USER_OBJ_TYPE is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeIsNotNull() {
            addCriterion("USER_OBJ_TYPE is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeEqualTo(Integer value) {
            addCriterion("USER_OBJ_TYPE =", value, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeNotEqualTo(Integer value) {
            addCriterion("USER_OBJ_TYPE <>", value, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeGreaterThan(Integer value) {
            addCriterion("USER_OBJ_TYPE >", value, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("USER_OBJ_TYPE >=", value, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeLessThan(Integer value) {
            addCriterion("USER_OBJ_TYPE <", value, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeLessThanOrEqualTo(Integer value) {
            addCriterion("USER_OBJ_TYPE <=", value, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeLike(Integer value) {
            addCriterion("USER_OBJ_TYPE like ", value, "USER_OBJ_TYPE", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeNotLike(Integer value) {
            addCriterion("USER_OBJ_TYPE  not like ", value, "USER_OBJ_TYPE", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeLeftLike(Integer value) {
            addCriterion("USER_OBJ_TYPE like ", value, "USER_OBJ_TYPE", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeNotLeftLike(Integer value) {
            addCriterion("USER_OBJ_TYPE  not like ", value, "USER_OBJ_TYPE", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeRightLike(Integer value) {
            addCriterion("USER_OBJ_TYPE like ", value, "USER_OBJ_TYPE", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeNotRightLike(Integer value) {
            addCriterion("USER_OBJ_TYPE  not like ", value, "USER_OBJ_TYPE", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeIn(List<Integer> values) {
            addCriterion("USER_OBJ_TYPE  in ", values, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeNotIn(List<Integer> values) {
            addCriterion("USER_OBJ_TYPE not in ", values, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeBetween(Integer value1, Integer value2) {
            addCriterion("USER_OBJ_TYPE between ", value1, value2, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("USER_OBJ_TYPE not between ", value1, value2, "USER_OBJ_TYPE");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andUserObjIdIsNull() {
            addCriterion("USER_OBJ_ID is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdIsNotNull() {
            addCriterion("USER_OBJ_ID is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdEqualTo(Integer value) {
            addCriterion("USER_OBJ_ID =", value, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdNotEqualTo(Integer value) {
            addCriterion("USER_OBJ_ID <>", value, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdGreaterThan(Integer value) {
            addCriterion("USER_OBJ_ID >", value, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("USER_OBJ_ID >=", value, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdLessThan(Integer value) {
            addCriterion("USER_OBJ_ID <", value, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdLessThanOrEqualTo(Integer value) {
            addCriterion("USER_OBJ_ID <=", value, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdLike(Integer value) {
            addCriterion("USER_OBJ_ID like ", value, "USER_OBJ_ID", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdNotLike(Integer value) {
            addCriterion("USER_OBJ_ID  not like ", value, "USER_OBJ_ID", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdLeftLike(Integer value) {
            addCriterion("USER_OBJ_ID like ", value, "USER_OBJ_ID", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdNotLeftLike(Integer value) {
            addCriterion("USER_OBJ_ID  not like ", value, "USER_OBJ_ID", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdRightLike(Integer value) {
            addCriterion("USER_OBJ_ID like ", value, "USER_OBJ_ID", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdNotRightLike(Integer value) {
            addCriterion("USER_OBJ_ID  not like ", value, "USER_OBJ_ID", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdIn(List<Integer> values) {
            addCriterion("USER_OBJ_ID  in ", values, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdNotIn(List<Integer> values) {
            addCriterion("USER_OBJ_ID not in ", values, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdBetween(Integer value1, Integer value2) {
            addCriterion("USER_OBJ_ID between ", value1, value2, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserObjIdNotBetween(Integer value1, Integer value2) {
            addCriterion("USER_OBJ_ID not between ", value1, value2, "USER_OBJ_ID");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andLoginNameIsNull() {
            addCriterion("LOGIN_NAME is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameIsNotNull() {
            addCriterion("LOGIN_NAME is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameEqualTo(String value) {
            addCriterion("LOGIN_NAME =", value, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameNotEqualTo(String value) {
            addCriterion("LOGIN_NAME <>", value, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameGreaterThan(String value) {
            addCriterion("LOGIN_NAME >", value, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameGreaterThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME >=", value, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameLessThan(String value) {
            addCriterion("LOGIN_NAME <", value, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameLessThanOrEqualTo(String value) {
            addCriterion("LOGIN_NAME <=", value, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameLike(String value) {
            addCriterion("LOGIN_NAME like ", value, "LOGIN_NAME", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameNotLike(String value) {
            addCriterion("LOGIN_NAME  not like ", value, "LOGIN_NAME", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameLeftLike(String value) {
            addCriterion("LOGIN_NAME like ", value, "LOGIN_NAME", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameNotLeftLike(String value) {
            addCriterion("LOGIN_NAME  not like ", value, "LOGIN_NAME", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameRightLike(String value) {
            addCriterion("LOGIN_NAME like ", value, "LOGIN_NAME", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameNotRightLike(String value) {
            addCriterion("LOGIN_NAME  not like ", value, "LOGIN_NAME", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameIn(List<String> values) {
            addCriterion("LOGIN_NAME  in ", values, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameNotIn(List<String> values) {
            addCriterion("LOGIN_NAME not in ", values, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME between ", value1, value2, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andLoginNameNotBetween(String value1, String value2) {
            addCriterion("LOGIN_NAME not between ", value1, value2, "LOGIN_NAME");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordLike(String value) {
            addCriterion("PASSWORD like ", value, "PASSWORD", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD  not like ", value, "PASSWORD", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordLeftLike(String value) {
            addCriterion("PASSWORD like ", value, "PASSWORD", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordNotLeftLike(String value) {
            addCriterion("PASSWORD  not like ", value, "PASSWORD", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordRightLike(String value) {
            addCriterion("PASSWORD like ", value, "PASSWORD", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordNotRightLike(String value) {
            addCriterion("PASSWORD  not like ", value, "PASSWORD", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD  in ", values, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in ", values, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between ", value1, value2, "PASSWORD");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between ", value1, value2, "PASSWORD");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andHeadImgUrlIsNull() {
            addCriterion("HEAD_IMG_URL is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlIsNotNull() {
            addCriterion("HEAD_IMG_URL is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlEqualTo(String value) {
            addCriterion("HEAD_IMG_URL =", value, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlNotEqualTo(String value) {
            addCriterion("HEAD_IMG_URL <>", value, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlGreaterThan(String value) {
            addCriterion("HEAD_IMG_URL >", value, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlGreaterThanOrEqualTo(String value) {
            addCriterion("HEAD_IMG_URL >=", value, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlLessThan(String value) {
            addCriterion("HEAD_IMG_URL <", value, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlLessThanOrEqualTo(String value) {
            addCriterion("HEAD_IMG_URL <=", value, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlLike(String value) {
            addCriterion("HEAD_IMG_URL like ", value, "HEAD_IMG_URL", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlNotLike(String value) {
            addCriterion("HEAD_IMG_URL  not like ", value, "HEAD_IMG_URL", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlLeftLike(String value) {
            addCriterion("HEAD_IMG_URL like ", value, "HEAD_IMG_URL", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlNotLeftLike(String value) {
            addCriterion("HEAD_IMG_URL  not like ", value, "HEAD_IMG_URL", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlRightLike(String value) {
            addCriterion("HEAD_IMG_URL like ", value, "HEAD_IMG_URL", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlNotRightLike(String value) {
            addCriterion("HEAD_IMG_URL  not like ", value, "HEAD_IMG_URL", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlIn(List<String> values) {
            addCriterion("HEAD_IMG_URL  in ", values, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlNotIn(List<String> values) {
            addCriterion("HEAD_IMG_URL not in ", values, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlBetween(String value1, String value2) {
            addCriterion("HEAD_IMG_URL between ", value1, value2, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andHeadImgUrlNotBetween(String value1, String value2) {
            addCriterion("HEAD_IMG_URL not between ", value1, value2, "HEAD_IMG_URL");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andPovertyAttrIsNull() {
            addCriterion("poverty_Attr is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrIsNotNull() {
            addCriterion("poverty_Attr is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrEqualTo(Integer value) {
            addCriterion("poverty_Attr =", value, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrNotEqualTo(Integer value) {
            addCriterion("poverty_Attr <>", value, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrGreaterThan(Integer value) {
            addCriterion("poverty_Attr >", value, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrGreaterThanOrEqualTo(Integer value) {
            addCriterion("poverty_Attr >=", value, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrLessThan(Integer value) {
            addCriterion("poverty_Attr <", value, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrLessThanOrEqualTo(Integer value) {
            addCriterion("poverty_Attr <=", value, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrLike(Integer value) {
            addCriterion("poverty_Attr like ", value, "poverty_Attr", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrNotLike(Integer value) {
            addCriterion("poverty_Attr  not like ", value, "poverty_Attr", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrLeftLike(Integer value) {
            addCriterion("poverty_Attr like ", value, "poverty_Attr", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrNotLeftLike(Integer value) {
            addCriterion("poverty_Attr  not like ", value, "poverty_Attr", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrRightLike(Integer value) {
            addCriterion("poverty_Attr like ", value, "poverty_Attr", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrNotRightLike(Integer value) {
            addCriterion("poverty_Attr  not like ", value, "poverty_Attr", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrIn(List<Integer> values) {
            addCriterion("poverty_Attr  in ", values, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrNotIn(List<Integer> values) {
            addCriterion("poverty_Attr not in ", values, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrBetween(Integer value1, Integer value2) {
            addCriterion("poverty_Attr between ", value1, value2, "poverty_Attr");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPovertyAttrNotBetween(Integer value1, Integer value2) {
            addCriterion("poverty_Attr not between ", value1, value2, "poverty_Attr");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andUserNameIsNull() {
            addCriterion("USER_NAME is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameIsNotNull() {
            addCriterion("USER_NAME is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameEqualTo(String value) {
            addCriterion("USER_NAME =", value, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameNotEqualTo(String value) {
            addCriterion("USER_NAME <>", value, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameGreaterThan(String value) {
            addCriterion("USER_NAME >", value, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("USER_NAME >=", value, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameLessThan(String value) {
            addCriterion("USER_NAME <", value, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameLessThanOrEqualTo(String value) {
            addCriterion("USER_NAME <=", value, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameLike(String value) {
            addCriterion("USER_NAME like ", value, "USER_NAME", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameNotLike(String value) {
            addCriterion("USER_NAME  not like ", value, "USER_NAME", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameLeftLike(String value) {
            addCriterion("USER_NAME like ", value, "USER_NAME", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameNotLeftLike(String value) {
            addCriterion("USER_NAME  not like ", value, "USER_NAME", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameRightLike(String value) {
            addCriterion("USER_NAME like ", value, "USER_NAME", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameNotRightLike(String value) {
            addCriterion("USER_NAME  not like ", value, "USER_NAME", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameIn(List<String> values) {
            addCriterion("USER_NAME  in ", values, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameNotIn(List<String> values) {
            addCriterion("USER_NAME not in ", values, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameBetween(String value1, String value2) {
            addCriterion("USER_NAME between ", value1, value2, "USER_NAME");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andUserNameNotBetween(String value1, String value2) {
            addCriterion("USER_NAME not between ", value1, value2, "USER_NAME");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andDepartmentIsNull() {
            addCriterion("department is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentIsNotNull() {
            addCriterion("department is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentEqualTo(String value) {
            addCriterion("department =", value, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentNotEqualTo(String value) {
            addCriterion("department <>", value, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentGreaterThan(String value) {
            addCriterion("department >", value, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentGreaterThanOrEqualTo(String value) {
            addCriterion("department >=", value, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentLessThan(String value) {
            addCriterion("department <", value, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentLessThanOrEqualTo(String value) {
            addCriterion("department <=", value, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentLike(String value) {
            addCriterion("department like ", value, "department", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentNotLike(String value) {
            addCriterion("department  not like ", value, "department", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentLeftLike(String value) {
            addCriterion("department like ", value, "department", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentNotLeftLike(String value) {
            addCriterion("department  not like ", value, "department", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentRightLike(String value) {
            addCriterion("department like ", value, "department", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentNotRightLike(String value) {
            addCriterion("department  not like ", value, "department", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentIn(List<String> values) {
            addCriterion("department  in ", values, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentNotIn(List<String> values) {
            addCriterion("department not in ", values, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentBetween(String value1, String value2) {
            addCriterion("department between ", value1, value2, "department");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andDepartmentNotBetween(String value1, String value2) {
            addCriterion("department not between ", value1, value2, "department");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andPhoneNumIsNull() {
            addCriterion("phone_num is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumIsNotNull() {
            addCriterion("phone_num is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumEqualTo(String value) {
            addCriterion("phone_num =", value, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumNotEqualTo(String value) {
            addCriterion("phone_num <>", value, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumGreaterThan(String value) {
            addCriterion("phone_num >", value, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumGreaterThanOrEqualTo(String value) {
            addCriterion("phone_num >=", value, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumLessThan(String value) {
            addCriterion("phone_num <", value, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumLessThanOrEqualTo(String value) {
            addCriterion("phone_num <=", value, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumLike(String value) {
            addCriterion("phone_num like ", value, "phone_num", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumNotLike(String value) {
            addCriterion("phone_num  not like ", value, "phone_num", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumLeftLike(String value) {
            addCriterion("phone_num like ", value, "phone_num", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumNotLeftLike(String value) {
            addCriterion("phone_num  not like ", value, "phone_num", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumRightLike(String value) {
            addCriterion("phone_num like ", value, "phone_num", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumNotRightLike(String value) {
            addCriterion("phone_num  not like ", value, "phone_num", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumIn(List<String> values) {
            addCriterion("phone_num  in ", values, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumNotIn(List<String> values) {
            addCriterion("phone_num not in ", values, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumBetween(String value1, String value2) {
            addCriterion("phone_num between ", value1, value2, "phone_num");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andPhoneNumNotBetween(String value1, String value2) {
            addCriterion("phone_num not between ", value1, value2, "phone_num");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andTownIdIsNull() {
            addCriterion("town_id is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdIsNotNull() {
            addCriterion("town_id is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdEqualTo(Integer value) {
            addCriterion("town_id =", value, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdNotEqualTo(Integer value) {
            addCriterion("town_id <>", value, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdGreaterThan(Integer value) {
            addCriterion("town_id >", value, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("town_id >=", value, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdLessThan(Integer value) {
            addCriterion("town_id <", value, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdLessThanOrEqualTo(Integer value) {
            addCriterion("town_id <=", value, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdLike(Integer value) {
            addCriterion("town_id like ", value, "town_id", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdNotLike(Integer value) {
            addCriterion("town_id  not like ", value, "town_id", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdLeftLike(Integer value) {
            addCriterion("town_id like ", value, "town_id", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdNotLeftLike(Integer value) {
            addCriterion("town_id  not like ", value, "town_id", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdRightLike(Integer value) {
            addCriterion("town_id like ", value, "town_id", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdNotRightLike(Integer value) {
            addCriterion("town_id  not like ", value, "town_id", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdIn(List<Integer> values) {
            addCriterion("town_id  in ", values, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdNotIn(List<Integer> values) {
            addCriterion("town_id not in ", values, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdBetween(Integer value1, Integer value2) {
            addCriterion("town_id between ", value1, value2, "town_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andTownIdNotBetween(Integer value1, Integer value2) {
            addCriterion("town_id not between ", value1, value2, "town_id");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andVillageIdIsNull() {
            addCriterion("village_id is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdIsNotNull() {
            addCriterion("village_id is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdEqualTo(Integer value) {
            addCriterion("village_id =", value, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdNotEqualTo(Integer value) {
            addCriterion("village_id <>", value, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdGreaterThan(Integer value) {
            addCriterion("village_id >", value, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("village_id >=", value, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdLessThan(Integer value) {
            addCriterion("village_id <", value, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdLessThanOrEqualTo(Integer value) {
            addCriterion("village_id <=", value, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdLike(Integer value) {
            addCriterion("village_id like ", value, "village_id", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdNotLike(Integer value) {
            addCriterion("village_id  not like ", value, "village_id", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdLeftLike(Integer value) {
            addCriterion("village_id like ", value, "village_id", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdNotLeftLike(Integer value) {
            addCriterion("village_id  not like ", value, "village_id", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdRightLike(Integer value) {
            addCriterion("village_id like ", value, "village_id", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdNotRightLike(Integer value) {
            addCriterion("village_id  not like ", value, "village_id", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdIn(List<Integer> values) {
            addCriterion("village_id  in ", values, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdNotIn(List<Integer> values) {
            addCriterion("village_id not in ", values, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdBetween(Integer value1, Integer value2) {
            addCriterion("village_id between ", value1, value2, "village_id");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andVillageIdNotBetween(Integer value1, Integer value2) {
            addCriterion("village_id not between ", value1, value2, "village_id");
            return (SysUserCriteria) this;
        }
        public SysUserCriteria andJobTitleIsNull() {
            addCriterion("job_title is null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleIsNotNull() {
            addCriterion("job_title is not null");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleEqualTo(String value) {
            addCriterion("job_title =", value, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleNotEqualTo(String value) {
            addCriterion("job_title <>", value, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleGreaterThan(String value) {
            addCriterion("job_title >", value, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleGreaterThanOrEqualTo(String value) {
            addCriterion("job_title >=", value, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleLessThan(String value) {
            addCriterion("job_title <", value, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleLessThanOrEqualTo(String value) {
            addCriterion("job_title <=", value, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleLike(String value) {
            addCriterion("job_title like ", value, "job_title", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleNotLike(String value) {
            addCriterion("job_title  not like ", value, "job_title", 1);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleLeftLike(String value) {
            addCriterion("job_title like ", value, "job_title", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleNotLeftLike(String value) {
            addCriterion("job_title  not like ", value, "job_title", 0);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleRightLike(String value) {
            addCriterion("job_title like ", value, "job_title", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleNotRightLike(String value) {
            addCriterion("job_title  not like ", value, "job_title", 2);
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleIn(List<String> values) {
            addCriterion("job_title  in ", values, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleNotIn(List<String> values) {
            addCriterion("job_title not in ", values, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleBetween(String value1, String value2) {
            addCriterion("job_title between ", value1, value2, "job_title");
            return (SysUserCriteria) this;
        }

        public SysUserCriteria andJobTitleNotBetween(String value1, String value2) {
            addCriterion("job_title not between ", value1, value2, "job_title");
            return (SysUserCriteria) this;
        }

    }

    public static class SysUserCriteria extends GeneratedCriteria {

        protected SysUserCriteria() {
            super();
        }
    }

    public static class SysUserCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected SysUserCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected SysUserCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected SysUserCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected SysUserCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected SysUserCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected SysUserCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}